Update Branch_Information  set Br_Code='WF'

alter table identitymaster alter column prefix char(2)

uPDATE identitymaster SET prefix=(Select br_code from Branch_Information)
where tablename = 'Customers'

Update Product_Categories_Level1 set Br_Code=(Select Br_Code from Branch_Information)
Update Product_Categories_Level2 set Br_Code=(Select Br_Code from Branch_Information)
Update Product_Master set Br_Code=(Select Br_Code from Branch_Information)
Update Product_Qty_PriceList set Br_Code=(Select Br_Code from Branch_Information)
Update Product_Supplier_BarCodes set Br_Code=(Select Br_Code from Branch_Information)
Update User_Logins set Br_Code=(Select Br_Code from Branch_Information)
Update Titles_Master set Br_Code=(Select Br_Code from Branch_Information)
Update Supplier_Details set Br_Code=(Select Br_Code from Branch_Information)
UPDATE SUBCATEGORIES SET BR_CODE=(Select Br_Code from Branch_Information)

update product_stocklist  set Br_Code=(Select Br_Code from Branch_Information)


go